package com.ourteam.workspace.dao;

import java.util.Arrays;
import java.util.List;
import java.util.Map;
import net.dao.BaseQueryBean;
import net.dao.BaseWhereCriterion;
import net.dao.IDataAccessInterface;
import org.apache.commons.lang.StringUtils;

/**
 * Template Name : DAO查询对象 Template Version : 1 Template Last Modfiy Date : Sat Aug 19 10:06:32 CST
 * 2017 Auto Generate Date : 2018-11-30 18:42:29 Warning ! This file will be overwrite when
 * regenerate !
 */
public class WorkspaceResourceDAOQueryBean extends BaseQueryBean {

  public WorkspaceResourceDAOQueryBean() {
    super();
  }

  public WorkspaceResourceDAOQueryBean(BaseQueryBean aQueryBean) {
    super(aQueryBean);
  }

  public WorkspaceResourceDAOQueryBean(BaseQueryBean aQueryBean, Map tableReplaceMap) {
    super(aQueryBean, tableReplaceMap);
  }

  public Criteria createCriteria() {

    Criteria criteria = createCriteriaInternal();
    if (oredCriteria.size() == 0) {
      oredCriteria.add(criteria);
    }
    return criteria;
  }

  protected Criteria createCriteriaInternal() {
    return new Criteria(this);
  }

  public void addIdSelectProperty() {
    addIdSelectProperty("id");
  }

  public void addIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.Id, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.Id, "id");
    }
  }

  public void addDescriptionSelectProperty() {
    addDescriptionSelectProperty("description");
  }

  public void addDescriptionSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.Description, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.Description, "description");
    }
  }

  public void addOrderIndexSelectProperty() {
    addOrderIndexSelectProperty("orderIndex");
  }

  public void addOrderIndexSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.OrderIndex, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.OrderIndex, "orderIndex");
    }
  }

  public void addResourcePathSelectProperty() {
    addResourcePathSelectProperty("resourcePath");
  }

  public void addResourcePathSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.ResourcePath, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.ResourcePath, "resourcePath");
    }
  }

  public void addResourceTypeSelectProperty() {
    addResourceTypeSelectProperty("resourceType");
  }

  public void addResourceTypeSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.ResourceType, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.ResourceType, "resourceType");
    }
  }

  public void addStatusSelectProperty() {
    addStatusSelectProperty("status");
  }

  public void addStatusSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.Status, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.Status, "status");
    }
  }

  public void addWorkspaceIdSelectProperty() {
    addWorkspaceIdSelectProperty("workspaceId");
  }

  public void addWorkspaceIdSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.WorkspaceId, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.WorkspaceId, "workspaceId");
    }
  }

  public void addNameSelectProperty() {
    addNameSelectProperty("name");
  }

  public void addNameSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.Name, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.Name, "name");
    }
  }

  public void addWorkspaceNameSelectProperty() {
    addWorkspaceNameSelectProperty("workspaceName");
  }

  public void addWorkspaceNameSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.WorkspaceName, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.WorkspaceName, "workspaceName");
    }
  }

  public void addWorkspacePathSelectProperty() {
    addWorkspacePathSelectProperty("workspacePath");
  }

  public void addWorkspacePathSelectProperty(String aAlias) {
    if (StringUtils.isNotBlank(aAlias)) {
      addSelectProperty(IWorkspaceResourceDAO.WorkspacePath, aAlias);
    } else {
      addSelectProperty(IWorkspaceResourceDAO.WorkspacePath, "workspacePath");
    }
  }

  public void addAllSelectProperties() {

    addIdSelectProperty();

    addDescriptionSelectProperty();

    addOrderIndexSelectProperty();

    addResourcePathSelectProperty();

    addResourceTypeSelectProperty();

    addStatusSelectProperty();

    addWorkspaceIdSelectProperty();

    addNameSelectProperty();

    addWorkspaceNameSelectProperty();

    addWorkspacePathSelectProperty();
  }

  public static class Criteria extends BaseWhereCriterion<WorkspaceResourceDAOQueryBean> {

    protected Criteria(WorkspaceResourceDAOQueryBean aParentObject) {
      super(aParentObject);
    }

    public Criteria andIdIsNull() {
      addCriterion(IWorkspaceResourceDAO.Id + " is null");
      return this;
    }

    public Criteria andIdIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.Id + " is not null");
      return this;
    }

    public Criteria andIdIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.Id + " is not null AND " + IWorkspaceResourceDAO.Id + " <> ''");
      return this;
    }

    public Criteria andIdIsEmpty() {
      addCriterion(
          "(" + IWorkspaceResourceDAO.Id + " is null OR " + IWorkspaceResourceDAO.Id + " = '')");
      return this;
    }

    public Criteria andIdEqualTo(long value) {
      return andIdEqualTo(Long.valueOf(value));
    }

    public Criteria andIdEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " = ", value, "id");
      return this;
    }

    public Criteria andIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotEqualTo(long value) {
      return andIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andIdNotEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " <>", value, "id");
      return this;
    }

    public Criteria andIdNotEqualToOrIsNull(long value) {
      return andIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IWorkspaceResourceDAO.Id + " is null OR " + IWorkspaceResourceDAO.Id + " <>",
          value,
          "id");
      return this;
    }

    public Criteria andIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThan(long value) {
      return andIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andIdGreaterThan(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " >", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(long value) {
      return andIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " >=", value, "id");
      return this;
    }

    public Criteria andIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThan(long value) {
      return andIdLessThan(Long.valueOf(value));
    }

    public Criteria andIdLessThan(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " <", value, "id");
      return this;
    }

    public Criteria andIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(long value) {
      return andIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.Id + " <=", value, "id");
      return this;
    }

    public Criteria andIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Id);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdIn(long[] values) {
      if (values.length == 1) {
        return andIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andIdEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " in", values, "id");
        return this;
      }
    }

    public Criteria andIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " not in", values, "id");
        return this;
      }
    }

    public Criteria andIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andIdEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andIdNotEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Id + " not in", Arrays.asList(values), "id");
        return this;
      }
    }

    public Criteria andIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Id + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andIdBetween(long value1, long value2) {
      addCriterion(IWorkspaceResourceDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IWorkspaceResourceDAO.Id + " between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(long value1, long value2) {
      addCriterion(IWorkspaceResourceDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IWorkspaceResourceDAO.Id + " not between", value1, value2, "id");
      return this;
    }

    public Criteria andDescriptionIsNull() {
      addCriterion(IWorkspaceResourceDAO.Description + " is null");
      return this;
    }

    public Criteria andDescriptionIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.Description + " is not null");
      return this;
    }

    public Criteria andDescriptionIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.Description
              + " is not null AND "
              + IWorkspaceResourceDAO.Description
              + " <> ''");
      return this;
    }

    public Criteria andDescriptionIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.Description
              + " is null OR "
              + IWorkspaceResourceDAO.Description
              + " = '')");
      return this;
    }

    public Criteria andDescriptionEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " = ", value, "description");
      return this;
    }

    public Criteria andDescriptionEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " <>", value, "description");
      return this;
    }

    public Criteria andDescriptionNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.Description
              + " is null OR "
              + IWorkspaceResourceDAO.Description
              + " <>",
          value,
          "description");
      return this;
    }

    public Criteria andDescriptionNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " >", value, "description");
      return this;
    }

    public Criteria andDescriptionGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " >=", value, "description");
      return this;
    }

    public Criteria andDescriptionGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " <", value, "description");
      return this;
    }

    public Criteria andDescriptionLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Description + " <=", value, "description");
      return this;
    }

    public Criteria andDescriptionLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Description);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andDescriptionLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.Description + " like", buffer.toString(), "description");
      return this;
    }

    public Criteria andDescriptionNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.Description + " not like", buffer.toString(), "description");
      return this;
    }

    public Criteria andDescriptionIn(List<String> values) {

      if (values.size() == 1) {
        return andDescriptionEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Description + " in", values, "description");
        return this;
      }
    }

    public Criteria andDescriptionNotIn(List<String> values) {
      if (values.size() == 1) {
        return andDescriptionNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Description + " not in", values, "description");
        return this;
      }
    }

    public Criteria andDescriptionIn(String[] values) {

      if (values.length == 1) {
        return andDescriptionEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.Description + " in", Arrays.asList(values), "description");
        return this;
      }
    }

    public Criteria andDescriptionNotIn(String[] values) {
      if (values.length == 1) {
        return andDescriptionNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.Description + " not in", Arrays.asList(values), "description");
        return this;
      }
    }

    public Criteria andDescriptionIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Description + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andDescriptionBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.Description + " between", value1, value2, "description");
      return this;
    }

    public Criteria andDescriptionNotBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.Description + " not between", value1, value2, "description");
      return this;
    }

    public Criteria andOrderIndexIsNull() {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " is null");
      return this;
    }

    public Criteria andOrderIndexIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " is not null");
      return this;
    }

    public Criteria andOrderIndexIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.OrderIndex
              + " is not null AND "
              + IWorkspaceResourceDAO.OrderIndex
              + " <> ''");
      return this;
    }

    public Criteria andOrderIndexIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.OrderIndex
              + " is null OR "
              + IWorkspaceResourceDAO.OrderIndex
              + " = '')");
      return this;
    }

    public Criteria andOrderIndexEqualTo(int value) {
      return andOrderIndexEqualTo(Integer.valueOf(value));
    }

    public Criteria andOrderIndexEqualTo(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " = ", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexNotEqualTo(int value) {
      return andOrderIndexNotEqualTo(Integer.valueOf(value));
    }

    public Criteria andOrderIndexNotEqualTo(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " <>", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexNotEqualToOrIsNull(int value) {
      return andOrderIndexNotEqualToOrIsNull(Integer.valueOf(value));
    }

    public Criteria andOrderIndexNotEqualToOrIsNull(java.lang.Integer value) {

      addCriterion(
          IWorkspaceResourceDAO.OrderIndex
              + " is null OR "
              + IWorkspaceResourceDAO.OrderIndex
              + " <>",
          value,
          "orderIndex");
      return this;
    }

    public Criteria andOrderIndexNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexGreaterThan(int value) {
      return andOrderIndexGreaterThan(Integer.valueOf(value));
    }

    public Criteria andOrderIndexGreaterThan(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " >", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexGreaterThanOrEqualTo(int value) {
      return andOrderIndexGreaterThanOrEqualTo(Integer.valueOf(value));
    }

    public Criteria andOrderIndexGreaterThanOrEqualTo(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " >=", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexLessThan(int value) {
      return andOrderIndexLessThan(Integer.valueOf(value));
    }

    public Criteria andOrderIndexLessThan(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " <", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexLessThanOrEqualTo(int value) {
      return andOrderIndexLessThanOrEqualTo(Integer.valueOf(value));
    }

    public Criteria andOrderIndexLessThanOrEqualTo(java.lang.Integer value) {

      addCriterion(IWorkspaceResourceDAO.OrderIndex + " <=", value, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.OrderIndex);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andOrderIndexLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexIn(int[] values) {
      if (values.length == 1) {
        return andOrderIndexEqualTo((java.lang.Integer) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.OrderIndex + " in", values, "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexNotIn(int[] values) {
      if (values.length == 1) {
        return andOrderIndexNotEqualTo((java.lang.Integer) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.OrderIndex + " not in", values, "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexIn(List<java.lang.Integer> values) {

      if (values.size() == 1) {
        return andOrderIndexEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.OrderIndex + " in", values, "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexNotIn(List<java.lang.Integer> values) {
      if (values.size() == 1) {
        return andOrderIndexNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.OrderIndex + " not in", values, "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexIn(java.lang.Integer[] values) {

      if (values.length == 1) {
        return andOrderIndexEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.OrderIndex + " in", Arrays.asList(values), "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexNotIn(java.lang.Integer[] values) {
      if (values.length == 1) {
        return andOrderIndexNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.OrderIndex + " not in", Arrays.asList(values), "orderIndex");
        return this;
      }
    }

    public Criteria andOrderIndexIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andOrderIndexBetween(int value1, int value2) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " between", value1, value2, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexBetween(java.lang.Integer value1, java.lang.Integer value2) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " between", value1, value2, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexNotBetween(int value1, int value2) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " not between", value1, value2, "orderIndex");
      return this;
    }

    public Criteria andOrderIndexNotBetween(java.lang.Integer value1, java.lang.Integer value2) {
      addCriterion(IWorkspaceResourceDAO.OrderIndex + " not between", value1, value2, "orderIndex");
      return this;
    }

    public Criteria andResourcePathIsNull() {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " is null");
      return this;
    }

    public Criteria andResourcePathIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " is not null");
      return this;
    }

    public Criteria andResourcePathIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.ResourcePath
              + " is not null AND "
              + IWorkspaceResourceDAO.ResourcePath
              + " <> ''");
      return this;
    }

    public Criteria andResourcePathIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.ResourcePath
              + " is null OR "
              + IWorkspaceResourceDAO.ResourcePath
              + " = '')");
      return this;
    }

    public Criteria andResourcePathEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " = ", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " <>", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.ResourcePath
              + " is null OR "
              + IWorkspaceResourceDAO.ResourcePath
              + " <>",
          value,
          "resourcePath");
      return this;
    }

    public Criteria andResourcePathNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " >", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " >=", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " <", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourcePath + " <=", value, "resourcePath");
      return this;
    }

    public Criteria andResourcePathLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourcePath);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourcePathLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " like", buffer.toString(), "resourcePath");
      return this;
    }

    public Criteria andResourcePathNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.ResourcePath + " not like", buffer.toString(), "resourcePath");
      return this;
    }

    public Criteria andResourcePathIn(List<String> values) {

      if (values.size() == 1) {
        return andResourcePathEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.ResourcePath + " in", values, "resourcePath");
        return this;
      }
    }

    public Criteria andResourcePathNotIn(List<String> values) {
      if (values.size() == 1) {
        return andResourcePathNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.ResourcePath + " not in", values, "resourcePath");
        return this;
      }
    }

    public Criteria andResourcePathIn(String[] values) {

      if (values.length == 1) {
        return andResourcePathEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.ResourcePath + " in", Arrays.asList(values), "resourcePath");
        return this;
      }
    }

    public Criteria andResourcePathNotIn(String[] values) {
      if (values.length == 1) {
        return andResourcePathNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.ResourcePath + " not in", Arrays.asList(values), "resourcePath");
        return this;
      }
    }

    public Criteria andResourcePathIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourcePathBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.ResourcePath + " between", value1, value2, "resourcePath");
      return this;
    }

    public Criteria andResourcePathNotBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.ResourcePath + " not between", value1, value2, "resourcePath");
      return this;
    }

    public Criteria andResourceTypeIsNull() {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " is null");
      return this;
    }

    public Criteria andResourceTypeIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " is not null");
      return this;
    }

    public Criteria andResourceTypeIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.ResourceType
              + " is not null AND "
              + IWorkspaceResourceDAO.ResourceType
              + " <> ''");
      return this;
    }

    public Criteria andResourceTypeIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.ResourceType
              + " is null OR "
              + IWorkspaceResourceDAO.ResourceType
              + " = '')");
      return this;
    }

    public Criteria andResourceTypeEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " = ", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " <>", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.ResourceType
              + " is null OR "
              + IWorkspaceResourceDAO.ResourceType
              + " <>",
          value,
          "resourceType");
      return this;
    }

    public Criteria andResourceTypeNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " >", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " >=", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " <", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.ResourceType + " <=", value, "resourceType");
      return this;
    }

    public Criteria andResourceTypeLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.ResourceType);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andResourceTypeLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.ResourceType + " like", buffer.toString(), "resourceType");
      return this;
    }

    public Criteria andResourceTypeNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.ResourceType + " not like", buffer.toString(), "resourceType");
      return this;
    }

    public Criteria andResourceTypeIn(List<String> values) {

      if (values.size() == 1) {
        return andResourceTypeEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.ResourceType + " in", values, "resourceType");
        return this;
      }
    }

    public Criteria andResourceTypeNotIn(List<String> values) {
      if (values.size() == 1) {
        return andResourceTypeNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.ResourceType + " not in", values, "resourceType");
        return this;
      }
    }

    public Criteria andResourceTypeIn(String[] values) {

      if (values.length == 1) {
        return andResourceTypeEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.ResourceType + " in", Arrays.asList(values), "resourceType");
        return this;
      }
    }

    public Criteria andResourceTypeNotIn(String[] values) {
      if (values.length == 1) {
        return andResourceTypeNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.ResourceType + " not in", Arrays.asList(values), "resourceType");
        return this;
      }
    }

    public Criteria andResourceTypeIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andResourceTypeBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.ResourceType + " between", value1, value2, "resourceType");
      return this;
    }

    public Criteria andResourceTypeNotBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.ResourceType + " not between", value1, value2, "resourceType");
      return this;
    }

    public Criteria andStatusIsNull() {
      addCriterion(IWorkspaceResourceDAO.Status + " is null");
      return this;
    }

    public Criteria andStatusIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.Status + " is not null");
      return this;
    }

    public Criteria andStatusIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.Status
              + " is not null AND "
              + IWorkspaceResourceDAO.Status
              + " <> ''");
      return this;
    }

    public Criteria andStatusIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.Status
              + " is null OR "
              + IWorkspaceResourceDAO.Status
              + " = '')");
      return this;
    }

    public Criteria andStatusEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " = ", value, "status");
      return this;
    }

    public Criteria andStatusEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " <>", value, "status");
      return this;
    }

    public Criteria andStatusNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.Status + " is null OR " + IWorkspaceResourceDAO.Status + " <>",
          value,
          "status");
      return this;
    }

    public Criteria andStatusNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " >", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " >=", value, "status");
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " <", value, "status");
      return this;
    }

    public Criteria andStatusLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Status + " <=", value, "status");
      return this;
    }

    public Criteria andStatusLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Status);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andStatusLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.Status + " like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.Status + " not like", buffer.toString(), "status");
      return this;
    }

    public Criteria andStatusIn(List<String> values) {

      if (values.size() == 1) {
        return andStatusEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Status + " in", values, "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(List<String> values) {
      if (values.size() == 1) {
        return andStatusNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Status + " not in", values, "status");
        return this;
      }
    }

    public Criteria andStatusIn(String[] values) {

      if (values.length == 1) {
        return andStatusEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Status + " in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusNotIn(String[] values) {
      if (values.length == 1) {
        return andStatusNotEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Status + " not in", Arrays.asList(values), "status");
        return this;
      }
    }

    public Criteria andStatusIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Status + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andStatusBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.Status + " between", value1, value2, "status");
      return this;
    }

    public Criteria andStatusNotBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.Status + " not between", value1, value2, "status");
      return this;
    }

    public Criteria andWorkspaceIdIsNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " is null");
      return this;
    }

    public Criteria andWorkspaceIdIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " is not null");
      return this;
    }

    public Criteria andWorkspaceIdIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceId
              + " is not null AND "
              + IWorkspaceResourceDAO.WorkspaceId
              + " <> ''");
      return this;
    }

    public Criteria andWorkspaceIdIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.WorkspaceId
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspaceId
              + " = '')");
      return this;
    }

    public Criteria andWorkspaceIdEqualTo(long value) {
      return andWorkspaceIdEqualTo(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " = ", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdNotEqualTo(long value) {
      return andWorkspaceIdNotEqualTo(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdNotEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " <>", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdNotEqualToOrIsNull(long value) {
      return andWorkspaceIdNotEqualToOrIsNull(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdNotEqualToOrIsNull(java.lang.Long value) {

      addCriterion(
          IWorkspaceResourceDAO.WorkspaceId
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspaceId
              + " <>",
          value,
          "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdGreaterThan(long value) {
      return andWorkspaceIdGreaterThan(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdGreaterThan(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " >", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdGreaterThanOrEqualTo(long value) {
      return andWorkspaceIdGreaterThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdGreaterThanOrEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " >=", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdLessThan(long value) {
      return andWorkspaceIdLessThan(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdLessThan(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " <", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdLessThanOrEqualTo(long value) {
      return andWorkspaceIdLessThanOrEqualTo(Long.valueOf(value));
    }

    public Criteria andWorkspaceIdLessThanOrEqualTo(java.lang.Long value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " <=", value, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceId);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceIdLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdIn(long[] values) {
      if (values.length == 1) {
        return andWorkspaceIdEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceId + " in", values, "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdNotIn(long[] values) {
      if (values.length == 1) {
        return andWorkspaceIdNotEqualTo((java.lang.Long) values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceId + " not in", values, "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdIn(List<java.lang.Long> values) {

      if (values.size() == 1) {
        return andWorkspaceIdEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceId + " in", values, "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdNotIn(List<java.lang.Long> values) {
      if (values.size() == 1) {
        return andWorkspaceIdNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceId + " not in", values, "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdIn(java.lang.Long[] values) {

      if (values.length == 1) {
        return andWorkspaceIdEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspaceId + " in", Arrays.asList(values), "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdNotIn(java.lang.Long[] values) {
      if (values.length == 1) {
        return andWorkspaceIdNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspaceId + " not in", Arrays.asList(values), "workspaceId");
        return this;
      }
    }

    public Criteria andWorkspaceIdIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceIdBetween(long value1, long value2) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " between", value1, value2, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceId + " between", value1, value2, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdNotBetween(long value1, long value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceId + " not between", value1, value2, "workspaceId");
      return this;
    }

    public Criteria andWorkspaceIdNotBetween(java.lang.Long value1, java.lang.Long value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceId + " not between", value1, value2, "workspaceId");
      return this;
    }

    public Criteria andNameIsNull() {
      addCriterion(IWorkspaceResourceDAO.Name + " is null");
      return this;
    }

    public Criteria andNameIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.Name + " is not null");
      return this;
    }

    public Criteria andNameIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.Name + " is not null AND " + IWorkspaceResourceDAO.Name + " <> ''");
      return this;
    }

    public Criteria andNameIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.Name
              + " is null OR "
              + IWorkspaceResourceDAO.Name
              + " = '')");
      return this;
    }

    public Criteria andNameEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " = ", value, "name");
      return this;
    }

    public Criteria andNameEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " <>", value, "name");
      return this;
    }

    public Criteria andNameNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.Name + " is null OR " + IWorkspaceResourceDAO.Name + " <>",
          value,
          "name");
      return this;
    }

    public Criteria andNameNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameNotEqualTo(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " >", value, "name");
      return this;
    }

    public Criteria andNameGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameGreaterThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " >=", value, "name");
      return this;
    }

    public Criteria andNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " <", value, "name");
      return this;
    }

    public Criteria andNameLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameLessThan(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.Name + " <=", value, "name");
      return this;
    }

    public Criteria andNameLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.Name);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andNameLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.Name + " like", buffer.toString(), "name");
      return this;
    }

    public Criteria andNameNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(IWorkspaceResourceDAO.Name + " not like", buffer.toString(), "name");
      return this;
    }

    public Criteria andNameIn(List<String> values) {

      if (values.size() == 1) {
        return andNameEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Name + " in", values, "name");
        return this;
      }
    }

    public Criteria andNameNotIn(List<String> values) {
      if (values.size() == 1) {
        return andNameNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.Name + " not in", values, "name");
        return this;
      }
    }

    public Criteria andNameIn(String[] values) {

      if (values.length == 1) {
        return andNameEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Name + " in", Arrays.asList(values), "name");
        return this;
      }
    }

    public Criteria andNameNotIn(String[] values) {
      if (values.length == 1) {
        return andNameNotEqualTo(values[0]);
      } else {
        addCriterion(IWorkspaceResourceDAO.Name + " not in", Arrays.asList(values), "name");
        return this;
      }
    }

    public Criteria andNameIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameNotIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.Name + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andNameBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.Name + " between", value1, value2, "name");
      return this;
    }

    public Criteria andNameNotBetween(String value1, String value2) {
      addCriterion(IWorkspaceResourceDAO.Name + " not between", value1, value2, "name");
      return this;
    }

    public Criteria andWorkspaceNameIsNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " is null");
      return this;
    }

    public Criteria andWorkspaceNameIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " is not null");
      return this;
    }

    public Criteria andWorkspaceNameIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName
              + " is not null AND "
              + IWorkspaceResourceDAO.WorkspaceName
              + " <> ''");
      return this;
    }

    public Criteria andWorkspaceNameIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.WorkspaceName
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspaceName
              + " = '')");
      return this;
    }

    public Criteria andWorkspaceNameEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " = ", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " <>", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspaceName
              + " <>",
          value,
          "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " >", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " >=", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " <", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " <=", value, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspaceName);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspaceNameLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName + " like", buffer.toString(), "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName + " not like", buffer.toString(), "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameIn(List<String> values) {

      if (values.size() == 1) {
        return andWorkspaceNameEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceName + " in", values, "workspaceName");
        return this;
      }
    }

    public Criteria andWorkspaceNameNotIn(List<String> values) {
      if (values.size() == 1) {
        return andWorkspaceNameNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspaceName + " not in", values, "workspaceName");
        return this;
      }
    }

    public Criteria andWorkspaceNameIn(String[] values) {

      if (values.length == 1) {
        return andWorkspaceNameEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspaceName + " in", Arrays.asList(values), "workspaceName");
        return this;
      }
    }

    public Criteria andWorkspaceNameNotIn(String[] values) {
      if (values.length == 1) {
        return andWorkspaceNameNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspaceName + " not in",
            Arrays.asList(values),
            "workspaceName");
        return this;
      }
    }

    public Criteria andWorkspaceNameIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspaceName + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspaceNameBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName + " between", value1, value2, "workspaceName");
      return this;
    }

    public Criteria andWorkspaceNameNotBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspaceName + " not between", value1, value2, "workspaceName");
      return this;
    }

    public Criteria andWorkspacePathIsNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " is null");
      return this;
    }

    public Criteria andWorkspacePathIsNotNull() {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " is not null");
      return this;
    }

    public Criteria andWorkspacePathIsNotEmpty() {
      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath
              + " is not null AND "
              + IWorkspaceResourceDAO.WorkspacePath
              + " <> ''");
      return this;
    }

    public Criteria andWorkspacePathIsEmpty() {
      addCriterion(
          "("
              + IWorkspaceResourceDAO.WorkspacePath
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspacePath
              + " = '')");
      return this;
    }

    public Criteria andWorkspacePathEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " = ", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" = ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " = ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathNotEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " <>", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathNotEqualToOrIsNull(String value) {

      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath
              + " is null OR "
              + IWorkspaceResourceDAO.WorkspacePath
              + " <>",
          value,
          "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathNotEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" <> ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathNotEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " <> ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathGreaterThan(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " >", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathGreaterThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" > ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathGreaterThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " > ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathGreaterThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " >=", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathGreaterThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" >= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathGreaterThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " >= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathLessThan(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " <", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathLessThanForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" < ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathLessThan(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " < ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathLessThanOrEqualTo(String value) {

      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " <=", value, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathLessThanOrEqualToForeignKey(java.lang.String key) {
      StringBuffer str = new StringBuffer(IWorkspaceResourceDAO.WorkspacePath);
      str.append(" <= ").append(key);
      addForeignKeyCriterion(str.toString());
      return this;
    }

    public Criteria andWorkspacePathLessThanOrEqualTo(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " <= ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath + " like", buffer.toString(), "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathNotLike(String value) {
      StringBuffer buffer = new StringBuffer("%");
      buffer.append(value);
      buffer.append("%");
      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath + " not like", buffer.toString(), "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathIn(List<String> values) {

      if (values.size() == 1) {
        return andWorkspacePathEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspacePath + " in", values, "workspacePath");
        return this;
      }
    }

    public Criteria andWorkspacePathNotIn(List<String> values) {
      if (values.size() == 1) {
        return andWorkspacePathNotEqualTo(values.get(0));
      } else {
        addCriterion(IWorkspaceResourceDAO.WorkspacePath + " not in", values, "workspacePath");
        return this;
      }
    }

    public Criteria andWorkspacePathIn(String[] values) {

      if (values.length == 1) {
        return andWorkspacePathEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspacePath + " in", Arrays.asList(values), "workspacePath");
        return this;
      }
    }

    public Criteria andWorkspacePathNotIn(String[] values) {
      if (values.length == 1) {
        return andWorkspacePathNotEqualTo(values[0]);
      } else {
        addCriterion(
            IWorkspaceResourceDAO.WorkspacePath + " not in",
            Arrays.asList(values),
            "workspacePath");
        return this;
      }
    }

    public Criteria andWorkspacePathIn(BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathNotIn(
        BaseQueryBean subQueryBean, IDataAccessInterface<?, ?> dao) {
      addCriterion(IWorkspaceResourceDAO.WorkspacePath + " not in ", subQueryBean, dao);
      return this;
    }

    public Criteria andWorkspacePathBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath + " between", value1, value2, "workspacePath");
      return this;
    }

    public Criteria andWorkspacePathNotBetween(String value1, String value2) {
      addCriterion(
          IWorkspaceResourceDAO.WorkspacePath + " not between", value1, value2, "workspacePath");
      return this;
    }
  }
}
